package com.app.model;


import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonInclude;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.sql.Timestamp;

@Data
@AllArgsConstructor
@NoArgsConstructor
@TableName("lm_mysql")
@JsonInclude(JsonInclude.Include.NON_NULL)

public class MysqlModel {
    @TableId(type = IdType.AUTO)
    private Integer id;
    private String mysqlIp;//mysql服务器的地址
    private String mysqlPort;//mysql服务器的端口
    private String mysqlCmd;//备份命令
    private String mysqlBackCmd;//恢复命令
    private String databaseName;//数据库名称
    private String backupsPath;//备份数据库地址
    private String size;//备份文件的大小

    private String backupsName;//备份文件名称
    private Integer operation;//操作次数
    private Integer status;//数据状态1正常0删除
    private Timestamp recoveryTime;//恢复时间
    private Timestamp createTime;//备份时间

    @TableField(exist = false)
    private String createTimeText;//备份时间格式化
    @TableField(exist = false)
    private String sizeText;//文件大小格式化
}
